﻿using Saisie_des_prélèvements.Models;
using System;
using System.Linq;
using System.Collections.ObjectModel;
using System.Collections.Generic;

namespace Saisie_des_prélèvements.ViewModels
{
    public class PLANCONTViewModel
    {
        #region Properties
        public string PC_CODE { get; set; }
        public string PC_LIBELLE { get; set; }
        #endregion Properties

        public List<PLANCONTViewModel> GetPlanControlSelection()
        {
            var db = new SQLite.SQLiteConnection(App.DBPath);
            List<PLANCONTViewModel> result = db.Query<PLANCONTViewModel>(
                "SELECT PC_CODE, PC_LIBELLE FROM PLANCONT ORDER BY PC_CODE"
                );

            return result;
        }
    }
}
